home *** CD-ROM | disk | FTP | other *** search
/ Belgian Amiga Club - ADF Collection / BS1 part 60.zip / BS1 part 60 / Prof. Calc d3.adf / Financial / Sources of Funds.PCF (.txt) < prev   
Gold Disk Spreadsheet  |  1991-12-11  |  7KB  |  142 lines
  1. Polar Bear Shirts Inc
  2.   Sources of Funds
  3. Source
  4. Current Assets
  5.   Cash
  6. 12000
  7. 30000
  8.   Accounts Receivable
  9. 35000
  10. 36000
  11.   Inventory
  12. 91000
  13. 86000
  14.   Raw Material
  15. 15000
  16. 17000
  17.   Work-In-Progress
  18.   Finished Goods
  19. 40000
  20. 50000
  21.  Finished Goods
  22.   Total Current Assets
  23. 201000
  24. 225000
  25.  Total Current Assets
  26. Fixed Assets
  27.   Land
  28.   Plant
  29. 355500
  30. 358500
  31.   Equipment
  32. 250000
  33. 240000
  34.  Equipment
  35. Total Fixed Assets
  36. 605500
  37. 598500
  38. otal Fixed Assets
  39. Total Assets:
  40. 806500
  41. 823500
  42. Current Liabilities
  43.   Accounts Payable
  44. 17000
  45. 19000
  46.   Salaries Payable
  47.   Taxes Payable
  48.   Short-term Loans
  49. Total Liabilites
  50. 25000
  51. 28000
  52. Long Term Debt
  53.   Term Loans
  54. 100000
  55. 100000
  56.   Bond Issues
  57.   SBA Loans
  58. 115000
  59. 112000
  60. Total Long-term Debt
  61. 215000
  62. 212000
  63. Net Worth
  64.   Preferred Stock
  65.   Common Stock
  66. 300000
  67. 300000
  68.   Retained Earnings
  69. 266500
  70. 283500
  71. Total Net Worth
  72. 566500
  73. 583500
  74. Liabilites + Equity
  75. 806500
  76. 823500
  77.     Revenues
  78. 250000
  79. 200000
  80.   Cost of Goods Sold
  81. 120000
  82. 100000
  83. Gross Profit
  84. 130000
  85. 100000
  86.  ----------
  87.   Rent
  88.   Depreciation
  89. 12000
  90. 14000
  91. 14000
  92.   Utilities
  93.   General Expenses
  94. 10000
  95. 19000
  96.   Advertising
  97. 18000
  98. 10000
  99.  ----------
  100.   Total Costs
  101. 56000
  102. 61000
  103. Operating Profit
  104. 74000
  105. 39000
  106.  ----------
  107.   Interest Expense
  108. 15000
  109. 18000
  110. Taxable Profit
  111. 59000
  112. 21000
  113.  ----------
  114.   Income Tax
  115. 14000
  116. After Tax Profit
  117. 45000
  118. 17000
  119. 17000
  120.   Dividends
  121.  ----------
  122. Retained Earnings
  123. 45000
  124. 17000
  125.  --------------------
  126. Sources of Funds
  127.   From Operations
  128.     After Tax Profit
  129. 17000
  130.     Depreciation
  131. 14000
  132.   Total From Operations
  133. 31000
  134.   Decrease in Assets
  135.   Total Sources
  136. 34000
  137. Uses of Funds
  138.   Increase in Assets
  139. 34000
  140.   Total Uses
  141. 34000
  142.